[dbo].[AtomPanelTemplate]

Property	Value
Created	10:31:13 AM Tuesday, March 02, 2010
Last Modified	11:40:00 AM Monday, February 20, 2012

Property

Value

Created

10:31:13 AM Tuesday, March 02, 2010

Last Modified

11:40:00 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_AtomPanelTemplate: WebsiteKey\AtomPanelTemplateTypeCode$	WebsiteKey	uniqueidentifier	16
$Cluster Primary Key PK_AtomPanelTemplate: WebsiteKey\AtomPanelTemplateTypeCode$	AtomPanelTemplateTypeCode	int	4
	TemplateName	nvarchar(30)	60
	TemplateXML	ntext	max
	DesignToPainterXSLT	ntext	max

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_AtomPanelTemplate: WebsiteKey\AtomPanelTemplateTypeCode$

WebsiteKey

uniqueidentifier

$Cluster Primary Key PK_AtomPanelTemplate: WebsiteKey\AtomPanelTemplateTypeCode$

AtomPanelTemplateTypeCode

int

TemplateName

nvarchar(30)

TemplateXML

ntext

max

DesignToPainterXSLT

ntext

max

	Name	Columns	Unique
$Cluster Primary Key PK_AtomPanelTemplate: WebsiteKey\AtomPanelTemplateTypeCode$	PK_AtomPanelTemplate	WebsiteKey, AtomPanelTemplateTypeCode

Name

Columns

Unique

$Cluster Primary Key PK_AtomPanelTemplate: WebsiteKey\AtomPanelTemplateTypeCode$

PK_AtomPanelTemplate

WebsiteKey, AtomPanelTemplateTypeCode

Name	Columns
FK_AtomPanelTemplate_AtomPanelTemplateTypeRef	AtomPanelTemplateTypeCode->[dbo].[AtomPanelTemplateTypeRef].[AtomPanelTemplateTypeCode]
FK_AtomPanelTemplate_Website	WebsiteKey->[dbo].[Website].[WebsiteKey]

Name

Columns

FK_AtomPanelTemplate_AtomPanelTemplateTypeRef

AtomPanelTemplateTypeCode->[dbo].[AtomPanelTemplateTypeRef].[AtomPanelTemplateTypeCode]

FK_AtomPanelTemplate_Website

WebsiteKey->[dbo].[Website].[WebsiteKey]

SQL Script

CREATE TABLE [dbo].[AtomPanelTemplate]
(
[WebsiteKey] [uniqueidentifier] NOT NULL,
[AtomPanelTemplateTypeCode] [int] NOT NULL,
[TemplateName] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TemplateXML] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DesignToPainterXSLT] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[AtomPanelTemplate] ADD CONSTRAINT [PK_AtomPanelTemplate] PRIMARY KEY CLUSTERED ([WebsiteKey], [AtomPanelTemplateTypeCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AtomPanelTemplate] ADD CONSTRAINT [FK_AtomPanelTemplate_AtomPanelTemplateTypeRef] FOREIGN KEY ([AtomPanelTemplateTypeCode]) REFERENCES [dbo].[AtomPanelTemplateTypeRef] ([AtomPanelTemplateTypeCode])
GO
ALTER TABLE [dbo].[AtomPanelTemplate] ADD CONSTRAINT [FK_AtomPanelTemplate_Website] FOREIGN KEY ([WebsiteKey]) REFERENCES [dbo].[Website] ([WebsiteKey])
GO